﻿using EmoneyWeiXinCommon;
using EmoneyWeiXinEntity;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace EmoneyWeiXinDAL
{
    public class TJ_Business_48HhyUserDAL
    {
        public List<TJ_Business_48HhyUserEntity> GetDataByTiemSpan(string startTime, string endTime, string weixinId)
        {
            string sql = "select * from  TJ_Business_48HhyUser with(nolock) where weixinId='" + weixinId + "' AND tradeDate>='" + startTime + "' AND tradeDate<='" + endTime + "' order by  CONVERT(varchar(12),tradeDate,112) desc,TradeHour asc";
            return SQLHelper.GetDataByColumnsLst<TJ_Business_48HhyUserEntity>(Config.EmoneyWeiXin, sql);
        }
    }
}
